Pandas Profiling Report

Dataset statistics

Number of variables	18
Number of observations	3000000
Missing cells	4725401
Missing cells (%)	8.8%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	412.0 MiB
Average record size in memory	144.0 B

Variable types

Text	6
Numeric	6
Categorical	5
DateTime	1

Alerts

`amount_due` is highly overall correlated with `payment_amount`	High correlation
`fine_amount` is highly overall correlated with `violation`	High correlation
`payment_amount` is highly overall correlated with `amount_due`	High correlation
`violation` is highly overall correlated with `fine_amount`	High correlation
`violation` is highly imbalanced (56.2%)	Imbalance
`issuing_agency` is highly imbalanced (90.0%)	Imbalance
`judgment_entry_date` has 2390812 (79.7%) missing values	Missing
`violation_status` has 2330658 (77.7%) missing values	Missing
`summons_number` has unique values	Unique
`summons_image` has unique values	Unique
`reduction_amount` has 2433302 (81.1%) zeros	Zeros
`payment_amount` has 782730 (26.1%) zeros	Zeros
`amount_due` has 2298078 (76.6%) zeros	Zeros

Reproduction

Analysis started	2023-12-05 19:24:09.095634
Analysis finished	2023-12-05 19:32:36.556686
Duration	8 minutes and 27.46 seconds
Software version	ydata-profiling vv4.6.2
Download configuration	config.json

plate
Text

Distinct	1380558
Distinct (%)	46.0%
Missing	14
Missing (%)	< 0.1%
Memory size	22.9 MiB

Length

Max length	10
Median length	7
Mean length	6.8697547
Min length	1

Characters and Unicode

Total characters	20609168
Distinct characters	51
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	867274 ?
Unique (%)	28.9%

Sample

1st row	KGY4654
2nd row	RBK1301
3rd row	KNB3224
4th row	KEW1301
5th row	8VUB416

Value	Count	Frequency (%)
96594mj	644	< 0.1%
blankplate	606	< 0.1%
2707086	577	< 0.1%
97306mc	544	< 0.1%
82923me	511	< 0.1%
40346jx	511	< 0.1%
77582mh	482	< 0.1%
60371mk	481	< 0.1%
13246mn	473	< 0.1%
xx165a	467	< 0.1%
Other values (1380544)	2994690	99.8%

Most occurring characters

Value	Count	Frequency (%)
1	1280783	6.2%
2	1272177	6.2%
7	1257892	6.1%
6	1251032	6.1%
3	1247740	6.1%
8	1235669	6.0%
4	1217978	5.9%
5	1215056	5.9%
9	1200942	5.8%
K	1020460	5.0%
Other values (41)	8409439	40.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	12143907	58.9%
Uppercase Letter	8465217	41.1%
Other Punctuation	35	< 0.1%
Lowercase Letter	5	< 0.1%
Math Symbol	3	< 0.1%
Open Punctuation	1	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
K	1020460	12.1%
J	646997	7.6%
M	604044	7.1%
H	519441	6.1%
L	410248	4.8%
N	397738	4.7%
G	380129	4.5%
C	371617	4.4%
T	341692	4.0%
A	338696	4.0%
Other values (16)	3434155	40.6%

Decimal Number

Value	Count	Frequency (%)
1	1280783	10.5%
2	1272177	10.5%
7	1257892	10.4%
6	1251032	10.3%
3	1247740	10.3%
8	1235669	10.2%
4	1217978	10.0%
5	1215056	10.0%
9	1200942	9.9%
0	964638	7.9%

Other Punctuation

Value	Count	Frequency (%)
.	13	37.1%
,	9	25.7%
&	7	20.0%
#	2	5.7%
'	1	2.9%
@	1	2.9%
;	1	2.9%
?	1	2.9%

Lowercase Letter

Value	Count	Frequency (%)
e	2	40.0%
i	1	20.0%
b	1	20.0%
t	1	20.0%

Math Symbol

Value	Count	Frequency (%)
+	2	66.7%
<	1	33.3%

Open Punctuation

Value	Count	Frequency (%)
{	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	12143946	58.9%
Latin	8465222	41.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
K	1020460	12.1%
J	646997	7.6%
M	604044	7.1%
H	519441	6.1%
L	410248	4.8%
N	397738	4.7%
G	380129	4.5%
C	371617	4.4%
T	341692	4.0%
A	338696	4.0%
Other values (20)	3434160	40.6%

Common

Value	Count	Frequency (%)
1	1280783	10.5%
2	1272177	10.5%
7	1257892	10.4%
6	1251032	10.3%
3	1247740	10.3%
8	1235669	10.2%
4	1217978	10.0%
5	1215056	10.0%
9	1200942	9.9%
0	964638	7.9%
Other values (11)	39	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	20609168	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	1280783	6.2%
2	1272177	6.2%
7	1257892	6.1%
6	1251032	6.1%
3	1247740	6.1%
8	1235669	6.0%
4	1217978	5.9%
5	1215056	5.9%
9	1200942	5.8%
K	1020460	5.0%
Other values (41)	8409439	40.8%

state
Text

Distinct	66
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	22.9 MiB

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	6000000
Distinct characters	27
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	NY
2nd row	NC
3rd row	NY
4th row	NY
5th row	CA

Value	Count	Frequency (%)
ny	2142391	71.4%
nj	279080	9.3%
pa	119604	4.0%
fl	66134	2.2%
ct	57317	1.9%
ga	33528	1.1%
in	29047	1.0%
ma	28521	1.0%
tx	28301	0.9%
va	26108	0.9%
Other values (56)	189969	6.3%

Most occurring characters

Value	Count	Frequency (%)
N	2492272	41.5%
Y	2144290	35.7%
J	279080	4.7%
A	245436	4.1%
P	120056	2.0%
C	107497	1.8%
T	100238	1.7%
L	85792	1.4%
M	72394	1.2%
F	66152	1.1%
Other values (17)	286793	4.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	5997234	> 99.9%
Decimal Number	2766	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	2492272	41.6%
Y	2144290	35.8%
J	279080	4.7%
A	245436	4.1%
P	120056	2.0%
C	107497	1.8%
T	100238	1.7%
L	85792	1.4%
M	72394	1.2%
F	66152	1.1%
Other values (16)	284027	4.7%

Decimal Number

Value	Count	Frequency (%)
9	2766	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5997234	> 99.9%
Common	2766	< 0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	2492272	41.6%
Y	2144290	35.8%
J	279080	4.7%
A	245436	4.1%
P	120056	2.0%
C	107497	1.8%
T	100238	1.7%
L	85792	1.4%
M	72394	1.2%
F	66152	1.1%
Other values (16)	284027	4.7%

Common

Value	Count	Frequency (%)
9	2766	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6000000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	2492272	41.5%
Y	2144290	35.7%
J	279080	4.7%
A	245436	4.1%
P	120056	2.0%
C	107497	1.8%
T	100238	1.7%
L	85792	1.4%
M	72394	1.2%
F	66152	1.1%
Other values (17)	286793	4.8%

license_type
Text

Distinct	70
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	22.9 MiB

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	9000000
Distinct characters	24
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	6 ?
Unique (%)	< 0.1%

Sample

1st row	PAS
2nd row	PAS
3rd row	PAS
4th row	PAS
5th row	PAS

Value	Count	Frequency (%)
pas	2391103	79.7%
com	408767	13.6%
omt	79865	2.7%
srf	22905	0.8%
999	17254	0.6%
oms	17136	0.6%
app	15882	0.5%
lmb	13752	0.5%
trc	5648	0.2%
mot	5573	0.2%
Other values (60)	22115	0.7%

Most occurring characters

Value	Count	Frequency (%)
S	2435744	27.1%
P	2427200	27.0%
A	2407826	26.8%
M	534304	5.9%
O	520643	5.8%
C	420454	4.7%
T	93279	1.0%
9	51762	0.6%
R	36581	0.4%
F	22906	0.3%
Other values (14)	49301	0.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	8948238	99.4%
Decimal Number	51762	0.6%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
S	2435744	27.2%
P	2427200	27.1%
A	2407826	26.9%
M	534304	6.0%
O	520643	5.8%
C	420454	4.7%
T	93279	1.0%
R	36581	0.4%
F	22906	0.3%
B	18603	0.2%
Other values (13)	30698	0.3%

Decimal Number

Value	Count	Frequency (%)
9	51762	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	8948238	99.4%
Common	51762	0.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
S	2435744	27.2%
P	2427200	27.1%
A	2407826	26.9%
M	534304	6.0%
O	520643	5.8%
C	420454	4.7%
T	93279	1.0%
R	36581	0.4%
F	22906	0.3%
B	18603	0.2%
Other values (13)	30698	0.3%

Common

Value	Count	Frequency (%)
9	51762	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	9000000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
S	2435744	27.1%
P	2427200	27.0%
A	2407826	26.8%
M	534304	5.9%
O	520643	5.8%
C	420454	4.7%
T	93279	1.0%
9	51762	0.6%
R	36581	0.4%
F	22906	0.3%
Other values (14)	49301	0.5%

summons_number
Real number (ℝ)

UNIQUE

Distinct	3000000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.4119661 × 10⁹

Minimum	1.0932299 × 10⁹
Maximum	9.0874659 × 10⁹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	22.9 MiB

Quantile statistics

Minimum	1.0932299 × 10⁹
5-th percentile	2.0040499 × 10⁹
Q1	8.8820087 × 10⁹
median	8.9737148 × 10⁹
Q3	9.0409399 × 10⁹
95-th percentile	9.0734028 × 10⁹
Maximum	9.0874659 × 10⁹
Range	7.994236 × 10⁹
Interquartile range (IQR)	1.5893115 × 10⁸

Descriptive statistics

Standard deviation	1.9066692 × 10⁹
Coefficient of variation (CV)	0.22666154
Kurtosis	8.0451838
Mean	8.4119661 × 10⁹
Median Absolute Deviation (MAD)	76864623
Skewness	-3.1606275
Sum	2.5235898 × 10¹⁶
Variance	3.6353873 × 10¹⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8827898402	1	< 0.1%
8893189010	1	< 0.1%
9017795268	1	< 0.1%
8915221564	1	< 0.1%
9017797046	1	< 0.1%
9017798981	1	< 0.1%
9017799262	1	< 0.1%
9046810860	1	< 0.1%
9042637572	1	< 0.1%
9050070280	1	< 0.1%
Other values (2999990)	2999990	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1093229913	1	< 0.1%
1131597850	1	< 0.1%
1131623435	1	< 0.1%
1157236935	1	< 0.1%
1253012726	1	< 0.1%
1253014735	1	< 0.1%
1253081980	1	< 0.1%
1256443670	1	< 0.1%
1256444765	1	< 0.1%
1256444790	1	< 0.1%

Value	Count	Frequency (%)
9087465919	1	< 0.1%
9087465816	1	< 0.1%
9087465749	1	< 0.1%
9087465567	1	< 0.1%
9087465397	1	< 0.1%
9087465270	1	< 0.1%
9087465166	1	< 0.1%
9087465075	1	< 0.1%
9087455690	1	< 0.1%
9087455677	1	< 0.1%

issue_date
Text

Distinct	1064
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	22.9 MiB

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	30000000
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	05/21/2021
2nd row	05/25/2021
3rd row	10/07/2021
4th row	05/25/2021
5th row	05/26/2021

Value	Count	Frequency (%)
11/25/2022	11452	0.4%
03/11/2021	9757	0.3%
11/26/2021	9592	0.3%
08/17/2023	9329	0.3%
08/22/2023	9273	0.3%
03/12/2021	9153	0.3%
05/23/2023	9058	0.3%
05/30/2023	8788	0.3%
05/19/2023	8707	0.3%
05/25/2023	8504	0.3%
Other values (1054)	2906387	96.9%

Most occurring characters

Value	Count	Frequency (%)
2	8615284	28.7%
0	6738708	22.5%
/	6000000	20.0%
1	3371648	11.2%
3	1701709	5.7%
8	693245	2.3%
5	625811	2.1%
7	614944	2.0%
6	607013	2.0%
9	534303	1.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	24000000	80.0%
Other Punctuation	6000000	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	8615284	35.9%
0	6738708	28.1%
1	3371648	14.0%
3	1701709	7.1%
8	693245	2.9%
5	625811	2.6%
7	614944	2.6%
6	607013	2.5%
9	534303	2.2%
4	497335	2.1%

Other Punctuation

Value	Count	Frequency (%)
/	6000000	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	30000000	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	8615284	28.7%
0	6738708	22.5%
/	6000000	20.0%
1	3371648	11.2%
3	1701709	5.7%
8	693245	2.3%
5	625811	2.1%
7	614944	2.0%
6	607013	2.0%
9	534303	1.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	30000000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	8615284	28.7%
0	6738708	22.5%
/	6000000	20.0%
1	3371648	11.2%
3	1701709	5.7%
8	693245	2.3%
5	625811	2.1%
7	614944	2.0%
6	607013	2.0%
9	534303	1.8%

violation_time
Text

Distinct	1528
Distinct (%)	0.1%
Missing	30
Missing (%)	< 0.1%
Memory size	22.9 MiB

Length

Max length	6
Median length	6
Mean length	5.9999977
Min length	5

Characters and Unicode

Total characters	17999813
Distinct characters	16
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	25 ?
Unique (%)	< 0.1%

Sample

1st row	07:44A
2nd row	06:35A
3rd row	12:12P
4th row	08:55A
5th row	08:46A

Value	Count	Frequency (%)
08:36a	20117	0.7%
08:38a	17262	0.6%
08:39a	17208	0.6%
08:40a	17057	0.6%
08:37a	16634	0.6%
08:41a	16213	0.5%
08:42a	15926	0.5%
08:43a	15107	0.5%
08:44a	14583	0.5%
08:06a	14555	0.5%
Other values (1519)	2835310	94.5%

Most occurring characters

Value	Count	Frequency (%)
0	3049622	16.9%
:	2999970	16.7%
1	2544579	14.1%
A	2155940	12.0%
2	1155071	6.4%
4	938429	5.2%
8	897278	5.0%
3	855852	4.8%
P	844023	4.7%
9	842150	4.7%
Other values (6)	1716899	9.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	11999876	66.7%
Other Punctuation	2999972	16.7%
Uppercase Letter	2999963	16.7%
Space Separator	2	< 0.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	3049622	25.4%
1	2544579	21.2%
2	1155071	9.6%
4	938429	7.8%
8	897278	7.5%
3	855852	7.1%
9	842150	7.0%
5	802890	6.7%
7	501002	4.2%
6	413003	3.4%

Other Punctuation

Value	Count	Frequency (%)
:	2999970	> 99.9%
.	1	< 0.1%
/	1	< 0.1%

Uppercase Letter

Value	Count	Frequency (%)
A	2155940	71.9%
P	844023	28.1%

Space Separator

Value	Count	Frequency (%)
	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	14999850	83.3%
Latin	2999963	16.7%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	3049622	20.3%
:	2999970	20.0%
1	2544579	17.0%
2	1155071	7.7%
4	938429	6.3%
8	897278	6.0%
3	855852	5.7%
9	842150	5.6%
5	802890	5.4%
7	501002	3.3%
Other values (4)	413007	2.8%

Latin

Value	Count	Frequency (%)
A	2155940	71.9%
P	844023	28.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	17999813	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	3049622	16.9%
:	2999970	16.7%
1	2544579	14.1%
A	2155940	12.0%
2	1155071	6.4%
4	938429	5.2%
8	897278	5.0%
3	855852	4.8%
P	844023	4.7%
9	842150	4.7%
Other values (6)	1716899	9.5%

violation
Categorical

HIGH CORRELATION IMBALANCE

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	22.9 MiB

NO PARKING-STREET CLEANING	1734224
NO PARKING-DAY/TIME LIMITS	763323
DOUBLE PARKING	371839
DOUBLE PARKING-MIDTOWN COMML	109988
NO PARKING-EXC. HOTEL LOADING	11504
Other values (7)	9122

Length

Max length	30
Median length	26
Mean length	24.586367
Min length	13

Characters and Unicode

Total characters	73759102
Distinct characters	26
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	DOUBLE PARKING
2nd row	DOUBLE PARKING
3rd row	NO PARKING-STREET CLEANING
4th row	NO PARKING-STREET CLEANING
5th row	NO PARKING-STREET CLEANING

Common Values

Value	Count	Frequency (%)
NO PARKING-STREET CLEANING	1734224	57.8%
NO PARKING-DAY/TIME LIMITS	763323	25.4%
DOUBLE PARKING	371839	12.4%
DOUBLE PARKING-MIDTOWN COMML	109988	3.7%
NO PARKING-EXC. HOTEL LOADING	11504	0.4%
ANGLE PARKING	4028	0.1%
NO PARKING-EXC. HNDICAP PERMIT	2306	0.1%
BUS PARKING IN LOWER MANHATTAN	1940	0.1%
NO PARKING-EXC. AUTH. VEHICLE	727	< 0.1%
ANGLE PARKING-COMM VEHICLE	81	< 0.1%
Other values (2)	40	< 0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
no	2512115	29.1%
cleaning	1734224	20.1%
parking-street	1734224	20.1%
parking-day/time	763323	8.8%
limits	763323	8.8%
double	481827	5.6%
parking	377807	4.4%
parking-midtown	109988	1.3%
comml	109988	1.3%
parking-exc	14537	0.2%
Other values (17)	41194	0.5%

Most occurring characters

Value	Count	Frequency (%)
N	9114339	12.4%
I	7153094	9.7%
E	6483852	8.8%
	5642550	7.6%
A	5522075	7.5%
T	5123579	6.9%
G	4749846	6.4%
R	4738488	6.4%
O	3238965	4.4%
L	3119227	4.2%
Other values (16)	18873087	25.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	64715763	87.7%
Space Separator	5642550	7.6%
Dash Punctuation	2622193	3.6%
Other Punctuation	778596	1.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	9114339	14.1%
I	7153094	11.1%
E	6483852	10.0%
A	5522075	8.5%
T	5123579	7.9%
G	4749846	7.3%
R	4738488	7.3%
O	3238965	5.0%
L	3119227	4.8%
P	3004612	4.6%
Other values (12)	12467686	19.3%

Other Punctuation

Value	Count	Frequency (%)
/	763332	98.0%
.	15264	2.0%

Space Separator

Value	Count	Frequency (%)
	5642550	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	2622193	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	64715763	87.7%
Common	9043339	12.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	9114339	14.1%
I	7153094	11.1%
E	6483852	10.0%
A	5522075	8.5%
T	5123579	7.9%
G	4749846	7.3%
R	4738488	7.3%
O	3238965	5.0%
L	3119227	4.8%
P	3004612	4.6%
Other values (12)	12467686	19.3%

Common

Value	Count	Frequency (%)
	5642550	62.4%
-	2622193	29.0%
/	763332	8.4%
.	15264	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	73759102	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	9114339	12.4%
I	7153094	9.7%
E	6483852	8.8%
	5642550	7.6%
A	5522075	7.5%
T	5123579	6.9%
G	4749846	6.4%
R	4738488	6.4%
O	3238965	4.4%
L	3119227	4.2%
Other values (16)	18873087	25.6%

judgment_entry_date
Date

MISSING

Distinct	93
Distinct (%)	< 0.1%
Missing	2390812
Missing (%)	79.7%
Memory size	22.9 MiB

Minimum	2011-05-19 00:00:00
Maximum	2023-11-30 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

fine_amount
Real number (ℝ)

HIGH CORRELATION

Distinct	16
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	72.647902

Minimum	35
Maximum	495
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	22.9 MiB

Quantile statistics

Minimum	35
5-th percentile	60
Q1	65
median	65
Q3	65
95-th percentile	115
Maximum	495
Range	460
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	19.264458
Coefficient of variation (CV)	0.26517569
Kurtosis	3.1676852
Mean	72.647902
Median Absolute Deviation (MAD)	0
Skewness	1.9012016
Sum	2.179437 × 10⁸
Variance	371.11933
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
65	2090497	69.7%
115	495274	16.5%
60	407838	13.6%
45	3932	0.1%
180	2306	0.1%
235	38	< 0.1%
335	36	< 0.1%
345	21	< 0.1%
315	21	< 0.1%
165	16	< 0.1%
Other values (6)	21	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
35	6	< 0.1%
45	3932	0.1%
60	407838	13.6%
65	2090497	69.7%
85	1	< 0.1%
95	4	< 0.1%
115	495274	16.5%
150	1	< 0.1%
165	16	< 0.1%
180	2306	0.1%

Value	Count	Frequency (%)
495	6	< 0.1%
435	3	< 0.1%
345	21	< 0.1%
335	36	< 0.1%
315	21	< 0.1%
235	38	< 0.1%
180	2306	0.1%
165	16	< 0.1%
150	1	< 0.1%
115	495274	16.5%

penalty_amount
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	22.9 MiB

0	1685462
60	638655
10	498472
30	177411

Length

Max length	2
Median length	1
Mean length	1.4381793
Min length	1

Characters and Unicode

Total characters	4314538
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	60
2nd row	60
3rd row	60
4th row	60
5th row	60

Common Values

Value	Count	Frequency (%)
0	1685462	56.2%
60	638655	21.3%
10	498472	16.6%
30	177411	5.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	1685462	56.2%
60	638655	21.3%
10	498472	16.6%
30	177411	5.9%

Most occurring characters

Value	Count	Frequency (%)
0	3000000	69.5%
6	638655	14.8%
1	498472	11.6%
3	177411	4.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	4314538	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	3000000	69.5%
6	638655	14.8%
1	498472	11.6%
3	177411	4.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	4314538	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	3000000	69.5%
6	638655	14.8%
1	498472	11.6%
3	177411	4.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4314538	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	3000000	69.5%
6	638655	14.8%
1	498472	11.6%
3	177411	4.1%

reduction_amount
Real number (ℝ)

ZEROS

Distinct	1732
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.6587664

Minimum	0
Maximum	350.26
Zeros	2433302
Zeros (%)	81.1%
Negative	0
Negative (%)	0.0%
Memory size	22.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	65
Maximum	350.26
Range	350.26
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	20.732714
Coefficient of variation (CV)	3.1135968
Kurtosis	13.959094
Mean	6.6587664
Median Absolute Deviation (MAD)	0
Skewness	3.6168733
Sum	19976299
Variance	429.84543
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2433302	81.1%
40	89376	3.0%
65	66068	2.2%
15	31950	1.1%
80	30562	1.0%
0.06	30284	1.0%
115	29156	1.0%
10	27820	0.9%
0.09	25775	0.9%
0.22	25416	0.8%
Other values (1722)	210291	7.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2433302	81.1%
0.01	1010	< 0.1%
0.02	1477	< 0.1%
0.03	15576	0.5%
0.04	4304	0.1%
0.05	1359	< 0.1%
0.06	30284	1.0%
0.07	1078	< 0.1%
0.08	778	< 0.1%
0.09	25775	0.9%

Value	Count	Frequency (%)
350.26	1	< 0.1%
330.26	1	< 0.1%
329.98	1	< 0.1%
247.21	1	< 0.1%
246.81	1	< 0.1%
241.65	1	< 0.1%
240	2	< 0.1%
210	7	< 0.1%
196.23	1	< 0.1%
193.92	1	< 0.1%

payment_amount
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	9828
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	57.130021

Minimum	0
Maximum	495.61
Zeros	782730
Zeros (%)	26.1%
Negative	0
Negative (%)	0.0%
Memory size	22.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	65
Q3	75
95-th percentile	125.65
Maximum	495.61
Range	495.61
Interquartile range (IQR)	75

Descriptive statistics

Standard deviation	42.299314
Coefficient of variation (CV)	0.74040432
Kurtosis	-0.40139383
Mean	57.130021
Median Absolute Deviation (MAD)	30
Skewness	0.18971452
Sum	1.7139006 × 10⁸
Variance	1789.232
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
65	1014155	33.8%
0	782730	26.1%
60	188424	6.3%
75	186831	6.2%
115	165193	5.5%
25	98796	3.3%
95	97902	3.3%
125	47306	1.6%
70	33029	1.1%
100	32203	1.1%
Other values (9818)	353431	11.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	782730	26.1%
0.01	6	< 0.1%
0.02	16	< 0.1%
0.03	1	< 0.1%
0.05	1	< 0.1%
0.06	7	< 0.1%
0.1	2	< 0.1%
0.11	1	< 0.1%
0.12	1	< 0.1%
0.14	1	< 0.1%

Value	Count	Frequency (%)
495.61	1	< 0.1%
357.01	1	< 0.1%
345.43	1	< 0.1%
345	7	< 0.1%
335	36	< 0.1%
330	1	< 0.1%
264.32	1	< 0.1%
262.44	1	< 0.1%
261.99	1	< 0.1%
258.6	1	< 0.1%

amount_due
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	11345
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	26.398221

Minimum	0
Maximum	522.49
Zeros	2298078
Zeros (%)	76.6%
Negative	0
Negative (%)	0.0%
Memory size	22.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	140.2
Maximum	522.49
Range	522.49
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	50.728846
Coefficient of variation (CV)	1.9216767
Kurtosis	1.3157613
Mean	26.398221
Median Absolute Deviation (MAD)	0
Skewness	1.6515214
Sum	79194663
Variance	2573.4158
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2298078	76.6%
75	150941	5.0%
140.24	68869	2.3%
125	41532	1.4%
134.55	31974	1.1%
65	31044	1.0%
70	30901	1.0%
115	26283	0.9%
95	26175	0.9%
195.79	19953	0.7%
Other values (11335)	274250	9.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2298078	76.6%
0.01	1	< 0.1%
0.09	1	< 0.1%
0.17	1	< 0.1%
0.22	1	< 0.1%
0.24	1	< 0.1%
0.32	1	< 0.1%
0.4	1	< 0.1%
0.56	1	< 0.1%
0.7	1	< 0.1%

Value	Count	Frequency (%)
522.49	1	< 0.1%
502.04	2	< 0.1%
449.59	1	< 0.1%
449.31	1	< 0.1%
395.29	2	< 0.1%
372.77	2	< 0.1%
358.39	21	< 0.1%
345	6	< 0.1%
313.6	2	< 0.1%
313.45	2	< 0.1%

precinct
Real number (ℝ)

Distinct	124
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	55.785967

Minimum	0
Maximum	809
Zeros	1165
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	22.9 MiB

Quantile statistics

Minimum	0
5-th percentile	6
Q1	19
median	52
Q3	84
95-th percentile	114
Maximum	809
Range	809
Interquartile range (IQR)	65

Descriptive statistics

Standard deviation	36.717009
Coefficient of variation (CV)	0.65817644
Kurtosis	-0.81100835
Mean	55.785967
Median Absolute Deviation (MAD)	32
Skewness	0.18100165
Sum	1.673579 × 10⁸
Variance	1348.1388
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
19	144153	4.8%
114	136527	4.6%
6	118974	4.0%
13	91704	3.1%
9	77310	2.6%
1	73075	2.4%
10	66650	2.2%
70	66356	2.2%
115	62329	2.1%
46	61475	2.0%
Other values (114)	2101447	70.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1165	< 0.1%
1	73075	2.4%
2	4	< 0.1%
3	7	< 0.1%
4	14	< 0.1%
5	43682	1.5%
6	118974	4.0%
7	34535	1.2%
8	1	< 0.1%
9	77310	2.6%

Value	Count	Frequency (%)
809	4	< 0.1%
807	2	< 0.1%
804	1	< 0.1%
803	1	< 0.1%
620	1	< 0.1%
619	1	< 0.1%
174	1	< 0.1%
163	4	< 0.1%
123	374	< 0.1%
122	1417	< 0.1%

county
Categorical

Distinct	9
Distinct (%)	< 0.1%
Missing	3861
Missing (%)	0.1%
Memory size	22.9 MiB

NY	1108470
K	777043
Q	565080
BX	401607
Kings	75504
Other values (4)	68435

Length

Max length	5
Median length	2
Mean length	1.6720182
Min length	1

Characters and Unicode

Total characters	5009599
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Q
2nd row	Q
3rd row	Q
4th row	Q
5th row	Q

Common Values

Value	Count	Frequency (%)
NY	1108470	36.9%
K	777043	25.9%
Q	565080	18.8%
BX	401607	13.4%
Kings	75504	2.5%
Bronx	39601	1.3%
Qns	21471	0.7%
R	7356	0.2%
Rich	7	< 0.1%
(Missing)	3861	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
ny	1108470	37.0%
k	777043	25.9%
q	565080	18.9%
bx	401607	13.4%
kings	75504	2.5%
bronx	39601	1.3%
qns	21471	0.7%
r	7356	0.2%
rich	7	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
N	1108470	22.1%
Y	1108470	22.1%
K	852547	17.0%
Q	586551	11.7%
B	441208	8.8%
X	401607	8.0%
n	136576	2.7%
s	96975	1.9%
i	75511	1.5%
g	75504	1.5%
Other values (6)	126180	2.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	4506216	90.0%
Lowercase Letter	503383	10.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	136576	27.1%
s	96975	19.3%
i	75511	15.0%
g	75504	15.0%
r	39601	7.9%
o	39601	7.9%
x	39601	7.9%
c	7	< 0.1%
h	7	< 0.1%

Uppercase Letter

Value	Count	Frequency (%)
N	1108470	24.6%
Y	1108470	24.6%
K	852547	18.9%
Q	586551	13.0%
B	441208	9.8%
X	401607	8.9%
R	7363	0.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5009599	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	1108470	22.1%
Y	1108470	22.1%
K	852547	17.0%
Q	586551	11.7%
B	441208	8.8%
X	401607	8.0%
n	136576	2.7%
s	96975	1.9%
i	75511	1.5%
g	75504	1.5%
Other values (6)	126180	2.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5009599	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	1108470	22.1%
Y	1108470	22.1%
K	852547	17.0%
Q	586551	11.7%
B	441208	8.8%
X	401607	8.0%
n	136576	2.7%
s	96975	1.9%
i	75511	1.5%
g	75504	1.5%
Other values (6)	126180	2.5%

issuing_agency
Categorical

IMBALANCE

Distinct	23
Distinct (%)	< 0.1%
Missing	26
Missing (%)	< 0.1%
Memory size	22.9 MiB

TRAFFIC	2768450
DEPARTMENT OF SANITATION	195036
POLICE DEPARTMENT	29894
OTHER/UNKNOWN AGENCIES	3726
PARKS DEPARTMENT	1964
Other values (18)	904

Length

Max length	35
Median length	7
Mean length	8.2339134
Min length	7

Characters and Unicode

Total characters	24701526
Distinct characters	26
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	TRAFFIC
2nd row	TRAFFIC
3rd row	TRAFFIC
4th row	TRAFFIC
5th row	TRAFFIC

Common Values

Value	Count	Frequency (%)
TRAFFIC	2768450	92.3%
DEPARTMENT OF SANITATION	195036	6.5%
POLICE DEPARTMENT	29894	1.0%
OTHER/UNKNOWN AGENCIES	3726	0.1%
PARKS DEPARTMENT	1964	0.1%
ROOSEVELT ISLAND SECURITY	183	< 0.1%
HEALTH AND HOSPITAL CORP. POLICE	175	< 0.1%
LONG ISLAND RAILROAD	124	< 0.1%
PARKING CONTROL UNIT	86	< 0.1%
CON RAIL	65	< 0.1%
Other values (13)	271	< 0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
traffic	2768450	80.8%
department	226945	6.6%
of	195045	5.7%
sanitation	195036	5.7%
police	30092	0.9%
other/unknown	3726	0.1%
agencies	3726	0.1%
parks	1975	0.1%
island	307	< 0.1%
health	185	< 0.1%
Other values (34)	2120	0.1%

Most occurring characters

Value	Count	Frequency (%)
F	5732075	23.2%
T	3617578	14.6%
A	3392701	13.7%
I	3193736	12.9%
R	3002565	12.2%
C	2802915	11.3%
N	633095	2.6%
E	496029	2.0%
O	429196	1.7%
	427633	1.7%
Other values (16)	974003	3.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	24269992	98.3%
Space Separator	427633	1.7%
Other Punctuation	3901	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
F	5732075	23.6%
T	3617578	14.9%
A	3392701	14.0%
I	3193736	13.2%
R	3002565	12.4%
C	2802915	11.5%
N	633095	2.6%
E	496029	2.0%
O	429196	1.8%
P	259501	1.1%
Other values (13)	710601	2.9%

Other Punctuation

Value	Count	Frequency (%)
/	3726	95.5%
.	175	4.5%

Space Separator

Value	Count	Frequency (%)
	427633	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	24269992	98.3%
Common	431534	1.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
F	5732075	23.6%
T	3617578	14.9%
A	3392701	14.0%
I	3193736	13.2%
R	3002565	12.4%
C	2802915	11.5%
N	633095	2.6%
E	496029	2.0%
O	429196	1.8%
P	259501	1.1%
Other values (13)	710601	2.9%

Common

Value	Count	Frequency (%)
	427633	99.1%
/	3726	0.9%
.	175	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	24701526	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
F	5732075	23.2%
T	3617578	14.6%
A	3392701	13.7%
I	3193736	12.9%
R	3002565	12.2%
C	2802915	11.3%
N	633095	2.6%
E	496029	2.0%
O	429196	1.7%
	427633	1.7%
Other values (16)	974003	3.9%

summons_image
Text

UNIQUE

Distinct	3000000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	22.9 MiB

Length

Max length	162
Median length	162
Mean length	162
Min length	162

Characters and Unicode

Total characters	486000000
Distinct characters	65
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3000000 ?
Unique (%)	100.0%

Sample

1st row	{'url': 'http://nycserv.nyc.gov/NYCServWeb/ShowImage?searchID=VDBSbmVVNTZaelZQUkZGM1RXYzlQUT09&locationName=_____________________', 'description': 'View Summons'}
2nd row	{'url': 'http://nycserv.nyc.gov/NYCServWeb/ShowImage?searchID=VDBSbmVVNTZaelZQUkdzd1RYYzlQUT09&locationName=_____________________', 'description': 'View Summons'}
3rd row	{'url': 'http://nycserv.nyc.gov/NYCServWeb/ShowImage?searchID=VDBScmQwMXFWWHBOUkZrd1RrRTlQUT09&locationName=_____________________', 'description': 'View Summons'}
4th row	{'url': 'http://nycserv.nyc.gov/NYCServWeb/ShowImage?searchID=VDBSbmVVNTZaelZQVkVsM1RVRTlQUT09&locationName=_____________________', 'description': 'View Summons'}
5th row	{'url': 'http://nycserv.nyc.gov/NYCServWeb/ShowImage?searchID=VDBSbmVVNTZaelZQVkdNeFRYYzlQUT09&locationName=_____________________', 'description': 'View Summons'}

Value	Count	Frequency (%)
url	3000000	20.0%
description	3000000	20.0%
view	3000000	20.0%
summons	3000000	20.0%
http://nycserv.nyc.gov/nycservweb/showimage?searchid=vdbsbk5vouvtvfzovkzfelrrrtlqut09&locationname	1	< 0.1%
http://nycserv.nyc.gov/nycservweb/showimage?searchid=vdbsbmvvntzhm2xpukzfmvqwrtlqut09&locationname	1	< 0.1%
http://nycserv.nyc.gov/nycservweb/showimage?searchid=vdbsbk5vouvwwgxoukvwnvqwrtlqut09&locationname	1	< 0.1%
http://nycserv.nyc.gov/nycservweb/showimage?searchid=vdbsbmvvntzhm2xpukuxm1qxrtlqut09&locationname	1	< 0.1%
http://nycserv.nyc.gov/nycservweb/showimage?searchid=vdbscmqwmxfwwhboukzrd1rrrtlqut09&locationname	1	< 0.1%
http://nycserv.nyc.gov/nycservweb/showimage?searchid=vdbsbmvvntzaelzqvkvsm1rvrtlqut09&locationname	1	< 0.1%
Other values (2999994)	2999994	20.0%

Most occurring characters

Value	Count	Frequency (%)
_	63000000	13.0%
e	25445702	5.2%
'	24000000	4.9%
o	18000000	3.7%
r	16215809	3.3%
c	15798057	3.3%
n	15000000	3.1%
V	14931288	3.1%
m	13108313	2.7%
t	12632881	2.6%
Other values (55)	267867950	55.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	227783714	46.9%
Uppercase Letter	101594853	20.9%
Connector Punctuation	63000000	13.0%
Other Punctuation	60000000	12.3%
Space Separator	12000000	2.5%
Decimal Number	9621433	2.0%
Math Symbol	6000000	1.2%
Close Punctuation	3000000	0.6%
Open Punctuation	3000000	0.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	25445702	11.2%
o	18000000	7.9%
r	16215809	7.1%
c	15798057	6.9%
n	15000000	6.6%
m	13108313	5.8%
t	12632881	5.5%
s	12632788	5.5%
a	12360617	5.4%
i	12000000	5.3%
Other values (14)	74589547	32.7%

Uppercase Letter

Value	Count	Frequency (%)
V	14931288	14.7%
S	12138186	11.9%
N	8261755	8.1%
Q	6025613	5.9%
I	6000000	5.9%
W	5860271	5.8%
T	5818568	5.7%
D	5768434	5.7%
U	5339310	5.3%
Y	4965612	4.9%
Other values (13)	26485816	26.1%

Other Punctuation

Value	Count	Frequency (%)
'	24000000	40.0%
/	12000000	20.0%
:	9000000	15.0%
.	6000000	10.0%
,	3000000	5.0%
&	3000000	5.0%
?	3000000	5.0%

Decimal Number

Value	Count	Frequency (%)
0	3522568	36.6%
9	3000000	31.2%
1	1982031	20.6%
5	758954	7.9%
2	264851	2.8%
3	93029	1.0%

Connector Punctuation

Value	Count	Frequency (%)
_	63000000	100.0%

Space Separator

Value	Count	Frequency (%)
	12000000	100.0%

Math Symbol

Value	Count	Frequency (%)
=	6000000	100.0%

Close Punctuation

Value	Count	Frequency (%)
}	3000000	100.0%

Open Punctuation

Value	Count	Frequency (%)
{	3000000	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	329378567	67.8%
Common	156621433	32.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	25445702	7.7%
o	18000000	5.5%
r	16215809	4.9%
c	15798057	4.8%
n	15000000	4.6%
V	14931288	4.5%
m	13108313	4.0%
t	12632881	3.8%
s	12632788	3.8%
a	12360617	3.8%
Other values (37)	173253112	52.6%

Common

Value	Count	Frequency (%)
_	63000000	40.2%
'	24000000	15.3%
/	12000000	7.7%
	12000000	7.7%
:	9000000	5.7%
=	6000000	3.8%
.	6000000	3.8%
0	3522568	2.2%
,	3000000	1.9%
}	3000000	1.9%
Other values (8)	15098865	9.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	486000000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
_	63000000	13.0%
e	25445702	5.2%
'	24000000	4.9%
o	18000000	3.7%
r	16215809	3.3%
c	15798057	3.3%
n	15000000	3.1%
V	14931288	3.1%
m	13108313	2.7%
t	12632881	2.6%
Other values (55)	267867950	55.1%

violation_status
Categorical

MISSING

Distinct	13
Distinct (%)	< 0.1%
Missing	2330658
Missing (%)	77.7%
Memory size	22.9 MiB

HEARING HELD-GUILTY	264524
HEARING HELD-GUILTY REDUCTION	217000
HEARING HELD-NOT GUILTY	125673
HEARING PENDING	44841
APPEAL AFFIRMED	6846
Other values (8)	10458

Length

Max length	29
Median length	26
Mean length	22.664424
Min length	15

Characters and Unicode

Total characters	15170251
Distinct characters	23
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	HEARING HELD-NOT GUILTY
2nd row	HEARING HELD-GUILTY REDUCTION
3rd row	APPEAL AFFIRMED
4th row	HEARING HELD-NOT GUILTY
5th row	HEARING HELD-NOT GUILTY

Common Values

Value	Count	Frequency (%)
HEARING HELD-GUILTY	264524	8.8%
HEARING HELD-GUILTY REDUCTION	217000	7.2%
HEARING HELD-NOT GUILTY	125673	4.2%
HEARING PENDING	44841	1.5%
APPEAL AFFIRMED	6846	0.2%
HEARING ADJOURNMENT	4827	0.2%
ADMIN REDUCTION	2424	0.1%
ADMIN CLAIM GRANTED	1513	0.1%
APPEAL REVERSED	818	< 0.1%
ADMIN CLAIM DENIED	493	< 0.1%
Other values (3)	383	< 0.1%
(Missing)	2330658	77.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
hearing	657007	39.0%
held-guilty	481524	28.6%
reduction	219424	13.0%
held-not	125673	7.5%
guilty	125673	7.5%
pending	44841	2.7%
appeal	7905	0.5%
affirmed	6846	0.4%
adjournment	4827	0.3%
admin	4430	0.3%
Other values (7)	5213	0.3%

Most occurring characters

Value	Count	Frequency (%)
E	1553809	10.2%
I	1542388	10.2%
G	1310558	8.6%
H	1264346	8.3%
L	1224447	8.1%
N	1108640	7.3%
	1014021	6.7%
T	959060	6.3%
D	891506	5.9%
R	891395	5.9%
Other values (13)	3410081	22.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	13548891	89.3%
Space Separator	1014021	6.7%
Dash Punctuation	607339	4.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	1553809	11.5%
I	1542388	11.4%
G	1310558	9.7%
H	1264346	9.3%
L	1224447	9.0%
N	1108640	8.2%
T	959060	7.1%
D	891506	6.6%
R	891395	6.6%
U	831448	6.1%
Other values (11)	1971294	14.5%

Space Separator

Value	Count	Frequency (%)
	1014021	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	607339	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	13548891	89.3%
Common	1621360	10.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	1553809	11.5%
I	1542388	11.4%
G	1310558	9.7%
H	1264346	9.3%
L	1224447	9.0%
N	1108640	8.2%
T	959060	7.1%
D	891506	6.6%
R	891395	6.6%
U	831448	6.1%
Other values (11)	1971294	14.5%

Common

Value	Count	Frequency (%)
	1014021	62.5%
-	607339	37.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	15170251	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	1553809	10.2%
I	1542388	10.2%
G	1310558	8.6%
H	1264346	8.3%
L	1224447	8.1%
N	1108640	7.3%
	1014021	6.7%
T	959060	6.3%
D	891506	5.9%
R	891395	5.9%
Other values (13)	3410081	22.5%

Auto

Heatmap
Table

	amount_due	county	fine_amount	issuing_agency	payment_amount	penalty_amount	precinct	reduction_amount	summons_number	violation	violation_status
amount_due	1.000	0.070	0.007	0.026	-0.690	0.448	0.015	-0.250	0.147	0.152	0.296
county	0.070	1.000	-0.024	0.294	0.021	0.107	0.152	0.065	-0.104	0.189	0.151
fine_amount	0.007	-0.024	1.000	0.078	0.219	0.034	-0.286	0.157	-0.004	0.535	0.383
issuing_agency	0.026	0.294	0.078	1.000	0.018	0.050	-0.063	0.050	0.462	0.101	0.067
payment_amount	-0.690	0.021	0.219	0.018	1.000	0.332	0.014	0.029	-0.075	0.237	0.326
penalty_amount	0.448	0.107	0.034	0.050	0.332	1.000	0.075	0.035	0.140	0.067	0.233
precinct	0.015	0.152	-0.286	-0.063	0.014	0.075	1.000	-0.210	-0.048	0.102	0.094
reduction_amount	-0.250	0.065	0.157	0.050	0.029	0.035	-0.210	1.000	-0.048	0.181	0.324
summons_number	0.147	-0.104	-0.004	0.462	-0.075	0.140	-0.048	-0.048	1.000	0.138	0.134
violation	0.152	0.189	0.535	0.101	0.237	0.067	0.102	0.181	0.138	1.000	0.104
violation_status	0.296	0.151	0.383	0.067	0.326	0.233	0.094	0.324	0.134	0.104	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	plate	state	license_type	summons_number	issue_date	violation_time	violation	judgment_entry_date	fine_amount	penalty_amount	reduction_amount	payment_amount	amount_due	precinct	county	issuing_agency	summons_image	violation_status
0	KGY4654	NY	PAS	8827898402	05/21/2021	07:44A	DOUBLE PARKING	07/28/2022	115	60	0.00	0.00	195.79	101	Q	TRAFFIC	{'url': 'http://nycserv.nyc.gov/NYCServWeb/ShowImage?searchID=VDBSbmVVNTZaelZQUkZGM1RXYzlQUT09&locationName=_____________________', 'description': 'View Summons'}	NaN
1	RBK1301	NC	PAS	8827898943	05/25/2021	06:35A	DOUBLE PARKING	07/28/2022	115	60	0.00	0.00	195.80	100	Q	TRAFFIC	{'url': 'http://nycserv.nyc.gov/NYCServWeb/ShowImage?searchID=VDBSbmVVNTZaelZQUkdzd1RYYzlQUT09&locationName=_____________________', 'description': 'View Summons'}	NaN
2	KNB3224	NY	PAS	8902530644	10/07/2021	12:12P	NO PARKING-STREET CLEANING	07/28/2022	65	60	0.00	137.97	0.00	102	Q	TRAFFIC	{'url': 'http://nycserv.nyc.gov/NYCServWeb/ShowImage?searchID=VDBScmQwMXFWWHBOUkZrd1RrRTlQUT09&locationName=_____________________', 'description': 'View Summons'}	NaN
3	KEW1301	NY	PAS	8827899200	05/25/2021	08:55A	NO PARKING-STREET CLEANING	07/28/2022	65	60	0.00	0.00	140.24	101	Q	TRAFFIC	{'url': 'http://nycserv.nyc.gov/NYCServWeb/ShowImage?searchID=VDBSbmVVNTZaelZQVkVsM1RVRTlQUT09&locationName=_____________________', 'description': 'View Summons'}	NaN
4	8VUB416	CA	PAS	8827899753	05/26/2021	08:46A	NO PARKING-STREET CLEANING	07/28/2022	65	60	0.00	0.00	140.24	107	Q	TRAFFIC	{'url': 'http://nycserv.nyc.gov/NYCServWeb/ShowImage?searchID=VDBSbmVVNTZaelZQVkdNeFRYYzlQUT09&locationName=_____________________', 'description': 'View Summons'}	NaN
5	JLA9682	NY	PAS	8827899807	05/26/2021	08:59A	NO PARKING-STREET CLEANING	07/28/2022	65	60	0.00	0.00	140.24	107	Q	TRAFFIC	{'url': 'http://nycserv.nyc.gov/NYCServWeb/ShowImage?searchID=VDBSbmVVNTZaelZQVkdkM1RuYzlQUT09&locationName=_____________________', 'description': 'View Summons'}	NaN
6	UHU2779	VA	PAS	8827899960	05/27/2021	02:06A	NO PARKING-DAY/TIME LIMITS	07/28/2022	60	60	0.00	0.00	134.55	107	Q	TRAFFIC	{'url': 'http://nycserv.nyc.gov/NYCServWeb/ShowImage?searchID=VDBSbmVVNTZaelZQVkdzeVRVRTlQUT09&locationName=_____________________', 'description': 'View Summons'}	NaN
7	2962540	IN	PAS	8898271190	06/23/2021	03:59P	NO PARKING-DAY/TIME LIMITS	NaN	65	0	65.00	0.00	0.00	1	NY	TRAFFIC	{'url': 'http://nycserv.nyc.gov/NYCServWeb/ShowImage?searchID=VDBSbk5VOUVTVE5OVkVVMVRVRTlQUT09&locationName=_____________________', 'description': 'View Summons'}	HEARING HELD-NOT GUILTY
8	76239MD	NY	COM	8898291474	09/22/2021	11:50A	NO PARKING-DAY/TIME LIMITS	10/20/2022	65	60	0.16	134.35	0.00	1	NY	TRAFFIC	{'url': 'http://nycserv.nyc.gov/NYCServWeb/ShowImage?searchID=VDBSbk5VOUVTVFZOVkZFelRrRTlQUT09&locationName=_____________________', 'description': 'View Summons'}	HEARING HELD-GUILTY REDUCTION
9	33163NA	NY	COM	8898316689	05/11/2021	12:01P	NO PARKING-DAY/TIME LIMITS	NaN	65	0	0.00	65.00	0.00	6	NY	TRAFFIC	{'url': 'http://nycserv.nyc.gov/NYCServWeb/ShowImage?searchID=VDBSbk5VOUVUWGhPYWxrMFQxRTlQUT09&locationName=_____________________', 'description': 'View Summons'}	APPEAL AFFIRMED

	plate	state	license_type	summons_number	issue_date	violation_time	violation	judgment_entry_date	fine_amount	penalty_amount	payment_amount	amount_due	precinct	county	issuing_agency	summons_image	violation_status
2999990	B80L07YC	NY	OMT	9077899479	09/21/2023	00:25A	NO PARKING-STREET CLEANING	NaN	65	10	0.0	75.0	103	Q	TRAFFIC	{'url': 'http://nycserv.nyc.gov/NYCServWeb/ShowImage?searchID=VDFSQk0wNTZaelZQVkZFelQxRTlQUT09&locationName=_____________________', 'description': 'View Summons'}	NaN
2999991	G50PPP	NJ	PAS	9077899492	09/21/2023	00:33A	NO PARKING-STREET CLEANING	NaN	65	30	0.0	95.0	103	Q	TRAFFIC	{'url': 'http://nycserv.nyc.gov/NYCServWeb/ShowImage?searchID=VDFSQk0wNTZaelZQVkZFMVRXYzlQUT09&locationName=_____________________', 'description': 'View Summons'}	NaN
2999992	JRV2751	NY	PAS	9077899510	09/21/2023	00:40A	NO PARKING-STREET CLEANING	NaN	65	30	0.0	95.0	113	Q	TRAFFIC	{'url': 'http://nycserv.nyc.gov/NYCServWeb/ShowImage?searchID=VDFSQk0wNTZaelZQVkZWNFRVRTlQUT09&locationName=_____________________', 'description': 'View Summons'}	NaN
2999993	LBD5860	NY	PAS	9077899546	09/21/2023	01:47A	NO PARKING-DAY/TIME LIMITS	NaN	60	30	0.0	90.0	103	Q	TRAFFIC	{'url': 'http://nycserv.nyc.gov/NYCServWeb/ShowImage?searchID=VDFSQk0wNTZaelZQVkZVd1RtYzlQUT09&locationName=_____________________', 'description': 'View Summons'}	NaN
2999994	HKX5517	NY	PAS	9079730658	09/15/2023	11:57A	NO PARKING-STREET CLEANING	NaN	65	30	95.0	0.0	77	K	TRAFFIC	{'url': 'http://nycserv.nyc.gov/NYCServWeb/ShowImage?searchID=VDFSQk0wOVVZM3BOUkZreFQwRTlQUT09&locationName=_____________________', 'description': 'View Summons'}	NaN
2999995	DA71826	IL	PAS	9079732394	09/22/2023	12:02P	NO PARKING-STREET CLEANING	NaN	65	10	75.0	0.0	88	K	TRAFFIC	{'url': 'http://nycserv.nyc.gov/NYCServWeb/ShowImage?searchID=VDFSQk0wOVVZM3BOYWswMVRrRTlQUT09&locationName=_____________________', 'description': 'View Summons'}	NaN
2999996	BEZ1176	NY	PAS	9086540119	10/15/2023	02:22P	NO PARKING-EXC. HOTEL LOADING	NaN	115	0	115.0	0.0	13	NY	TRAFFIC	{'url': 'http://nycserv.nyc.gov/NYCServWeb/ShowImage?searchID=VDFSQk5FNXFWVEJOUkVWNFQxRTlQUT09&locationName=_____________________', 'description': 'View Summons'}	NaN
2999997	GRA6091	NY	PAS	9079735140	09/15/2023	08:08A	NO PARKING-STREET CLEANING	NaN	65	30	95.0	0.0	107	Q	TRAFFIC	{'url': 'http://nycserv.nyc.gov/NYCServWeb/ShowImage?searchID=VDFSQk0wOVVZM3BPVkVVd1RVRTlQUT09&locationName=_____________________', 'description': 'View Summons'}	NaN
2999998	LPZ4310	PA	PAS	9077900019	09/08/2023	12:43P	NO PARKING-STREET CLEANING	NaN	65	30	0.0	95.0	102	Q	TRAFFIC	{'url': 'http://nycserv.nyc.gov/NYCServWeb/ShowImage?searchID=VDFSQk0wNTZhM2ROUkVGNFQxRTlQUT09&locationName=_____________________', 'description': 'View Summons'}	NaN
2999999	HEG9632	NY	PAS	9077900020	09/08/2023	12:46P	NO PARKING-STREET CLEANING	NaN	65	30	0.0	95.0	102	Q	TRAFFIC	{'url': 'http://nycserv.nyc.gov/NYCServWeb/ShowImage?searchID=VDFSQk0wNTZhM2ROUkVGNVRVRTlQUT09&locationName=_____________________', 'description': 'View Summons'}	NaN

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Other Punctuation

Lowercase Letter

Math Symbol

Open Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Other Punctuation

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common